Kelly P.
Kelly P.
Reactions
-
Re: Edit reports on a dashboard
@Marc Shecter One workaround that I have used in the past is to use the Web Content widget on the dashboard in conjunction with the embed code option in the publish settings of the sheet (edit by any…4 · -
Report Builder - toggle column list order
It would be helpful to have a toggle (or some other way to make a choice) in the columns section of the report builder: Alpha or Sheet Order. Most reports mirror the layout of the underlying sheets t…4 · -
Re: Need help with a SUM/LEFT formula
@Matt_Fastenal1 You'll need to restructure your formula to follow this pattern: =SUM(VALUE(LEFT([1. Accuracy of product ordered]@row, 1)) + VALUE(LEFT([2. Condition of product and packaging]@row, 1))…1 · -
Re: Need a formula to trigger a red flag
@Missy Folkemer If you indent all of the rows under the first row, then you can place the formula below in the first row of your Flag column. It will flag itself if any of the children are flagged. =…1 · -
Re: How would I split text separated by commas into new cells?
Let's say that your text "Boston, MA, USA" is in a column called "Location" and that you want to separate the text into three columns called City, State, and Country. The formulas…1 ·
